IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'spAttachmentDelete') AND type in (N'P', N'PC'))
	DROP PROCEDURE spAttachmentDelete
GO
-- =============================================
-- Author:	Nam Tran
-- Create date: Sep 23, 2014
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[spAttachmentDelete]
	@AttachmentId BIGINT
AS
BEGIN
	DELETE FROM [Attachment] WHERE [Id] = @AttachmentId

	SELECT cast(@@ROWCOUNT AS INT)
END